Index provides a faster access path to table data. It is created using one or more columns of a table to speed SQL statement execution on that table.
Just simply click ->
Index to open
an object pane for Index. A control-click displays the popup
menu or using the object pane toolbar below, allowing you to create new, edit
and delete the selected Index.
Create Index
To create a new index
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Index from the popup menu.
- Edit index properties on the appropriate tabs of the Index Designer.
To create a new index with modification as one of the existing index
- Select the index for modifying in the object pane.
- Control-click and select the Design
Index from the popup menu or simply double-click the index.
or - Click the
from the object pane toolbar.
- Modify index properties on the appropriate tabs of the Index Designer.
- Click
Save As.
Edit Index
To edit the existing index (manage its properties etc)
- Select the index for editing in the object pane.
- Control-click and select the Design
Index from the popup menu or simply double-click the index.
or - Click the
from the object pane toolbar.
- Edit index properties on the appropriate tabs of the Index Designer.
To change the name of the index
- Select the index for editing in the object pane.
- Control-click and select the Rename from the popup menu.
Maintain Index
To maintain an index
- Select the index for maintaining in the object pane.
- Control-click and select the Maintain from the popup menu.
- Rebuild Index
- Make Index Unusable
- Coalesce Index
- Compute Index Statistics
Delete Index
To delete an index
- Select the index for deleting in the object pane.
- Control-click and select the Delete Index
from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Achieve Index Information
To achieve an index information
- Select the index in the object pane.
- Choose View -> Object Information in the main menu to view the Object Information.
or - Click the
from the object pane toolbar.